Select ... From (Select ...)? - Mailing list pgsql-novice

From Steven O'Toole
Subject Select ... From (Select ...)?
Date
Msg-id a05001950b6ea9bda45f5@[192.168.1.47]
Whole thread Raw
Responses Re: Select ... From (Select ...)?
List pgsql-novice
Is there any way to do this kind of query in PGSQL?

SELECT count0, count1 FROM (
SELECT COUNT(*) AS count0
FROM measurement
WHERE responseTime = 0
GROUP BY responseTime
), (
SELECT COUNT(*) AS count1
FROM measurement
WHERE responseTime = 1
GROUP BY responseTime
)
;

pgsql-novice by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: DELETE FROM fails
Next
From: José Luiz
Date:
Subject: Error during update from version 6.5.3 to version 7.03